A Distributed Group Commit Protocol for Distributed Database Systems

This paper identiies the problems of the group commit protocol for the distributed main memory database systems, and presents a distributed group commit protocol. In the proposed protocol, a consistent set of transactions which have to be committed together is identiied during the normal transaction processing, by propagating the transaction precedence relations as the normal transaction messages are exchanged. Moreover, the log entries of the identiied transactions are propagated to the related sites during normal transaction processing. Hence, no delay for precedence relation tracking is required at commit time and the log entries of the consistent set of transactions can be ushed into the stable log by any one of the related sites. As a result, the frequency of the communication and the disk access related to the commit processing can be signiicantly reduced. Our simulation study shows that the proposed commit protocol achieves the high performance without any consistency problem.